PrepayHistory

Entity Definition

Logical Name : PrepayHistory
Physical Name : LE_HST_PRPY

The total number and monetary value of all Prepay and PrepayRefund FuelSaleLineItems that were sold to a FuelingPoint during a ReportingPeriod.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer ReportingPeriod(CA_PRD_RP)
FuelingPointID (FK)(PK) A unique identifier for the FuelingPoint at a particular retail store ID_PNT_FUEL Identity integer FuelingPoint(AS_PNT_FUEL)
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer FuelingPoint(AS_PNT_FUEL)
PrepayFuelingTransactionCount The number of prepay FuellingTransactions performed at the FuellingPoint during the ReportingPeriod QU_TRN_FUEL_PSPY QuantityTransactionCount decimal(7,0)
PrepayFuelingTransactionTotalAmount The total monetary amount of prepay FuellingTransactions performed at the FuellingPoint during the ReportingPeriod MO_TRN_FUEL_PSPY Money decimal(16,5)
PrepayFuelingRefundCount The number of prepay refund FuellingTransactions performed at the FuellingPoint during the ReportingPeriod QU_RFD_FUEL_PSPY QuantityTransactionCount decimal(7,0)
PrepayFuelingRefundAmount The total monetary value of prepay refund FuellingTransactions performed at the FuellingPoint during the ReportingPeriod MO_RFD_FUEL_PSPY Money decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
FuelingPoint is summarized by PrepayHistory
ReportingPeriod delineates PrepayHistory

Logical Views containing PrepayHistory

Logical View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 20040 - Forecourt History View